Page 82 - Data_Science_Part_A C12

B. Fill in the blanks.

1. are pre-defined formula in Calc.

2. The location of the selected cell is displayed in the .
3. The steps to apply filter are click on AutoFilter.

4. The is called the active cell and is highlighted with a thick border.

5. In Calc, any cell address is created with and .

C. State whether these statements are true or false.

1. A special character can be inserted by Data Insert Special character.
2. You can insert animations in any slide of the presentation.

3. A worksheet can contain many workbooks.

4. Save option is available in Slide menu in Impress presentation software.

5. Having a layout helps to arrange the content on the slide in a desired way.

Standard Questions (Section B)

A. Short answer type questions:
1. What is a slide?

2. What is the extension of a presentation file in Impress?
3. Give the steps to apply Standard Filter in Spreadsheet.

4. What is Sorting in Spreadsheet Software? Give steps for sorting.
5. Identify the following icons and state their purpose:

a. b. c.

B. Long answer type questions:
1. What are the advantages of presentation software?

2. What is cell address? Explain with the help of an example.

3. Arrange the jumbled steps and rewrite to copy and paste content in a slide:
i. Press ‘Ctrl+V’ keys from the keyboard.
ii. Place the insertion point on the desired area where the content is required to appear.
iii. The copied text will appear at the insertion point.
iv. Select the content to be copied, then click the ‘Copy’ command on the standard toolbar.

4. What are the various ways in which we edit or format a slide? Explain any two.

5. What basic operations can you perform in a spreadsheet? Write down the steps to perform any two such basic
operations.

80 Touchpad Data Science-XII